indicator | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|---|---|
GDP | 11106306 | 11334208.4 | 11547055.1 | 10905718.3 | 11590843.7 | 11988631.7 | 12054187.6 | 12184743.8 |
CPI_link | NA | 101.8 | 101.4 | 100.7 | 102.9 | 109.2 | 106.4 | 102.6 |
Chapter I - Statistics I - Exercises
This is a set of exercises created by the teaching Faculty for Statistics I, Chapter I - Index Numbers, from the Lisbon Accounting and Business School.
Questions
Question 1
Consider the following sales data, in thousands of euros, for a given company:
Year | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|
Sales | 500 | 650 | 600 | 800 | 750 | 950 |
- Build the index series with fix base in 2019.
Year | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|
\(I^{sales}_{t|2019}\) |
We could say that in year 2021, according to the index computed above, sales increased 20% relative to the base year.
Study the evolution of sales, between consecutive years.
We need to compute the link or chain index.
Year | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|
Sales | 500 | 650 | 600 | 800 | 750 | 950 |
\(I^{sales}_{chain}\) | 130 | 92.3 | 133.3 | 93.8 | 126.7 |
From 2019 to 2020 sales grew by 30%, from 2020 to 2021 sales diminished 7.7%, from 2021 to 2022 sales grew 33.3%, from 2022 to 2023 sales dropped 6.2%, and from 2023 to 2024 sales grew 26.7%.
- What happened to sales during the whole studied period?
Sales grew 90%, between 2019 and 2024.
The growth rate between 2021 and 2023 was
The (rounded) average growth rate in the studied period is
Question 2
Consider the following sales data, in thousands of euros, for a given company:
Year | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|
Sales | 300 | 250 | \(a\) | 240 | \(b\) | 340 |
The average growth rate for sales, between 2019 and 2024 was, approximately, 2.53%.
Let \(i_{2021|2019}=67\). Also, assume you know that the growth rate doubled between 2022 and 2023. The values for \(a\) and \(b\) are respectively:
The average growth rate needed to triple sales between 2024 and 2028 would have to be 31.61%.
Assuming an average growth rate of 10%, it would be necessary to wait for 6 years for sales to triple.
Question 3
A given company presented their financial statements with the following information:
Year | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|
Growth rate of sales | 20% | 15% | 20% | 10% | 25% | |
Price Index (base = 2021) | 81.17 | 89.29 | 100 | 115 | 128.8 | 148.12 |
Write the average growth rate of (nominal) sales for the whole period (rounded up, for example 11 if percentage, or 0.11 if decimal):
Find the annual real growth rate for sales, when this was negative.
Start building the index for sales, base 2021, and remember \(i^v_{t|b}=i^q_{t|b}\times i^p_{t|b}\) to build the real growth rates:
Year | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|
Sales Index (base = 2021) | 72.46 | 86.96 | 100 | 120 | 132 | 165 |
Price Index (base = 2021) | 81.17 | 89.29 | 100 | 115 | 128.8 | 148.12 |
Real Sales Index (base = 2021) | 89.27 | 97.39 | 100 | 104.35 | 102.48 | 111.4 |
Clearly, the real growth rate was negative in 2023, and it was -1.79%.
- How do you interpret the price index for years 2019 and 2020?
From 2019 to 2021 prices grew 23.2 %, and from 2020 to 2021 prices grew 11.99 %.
Question 4
For some country, water consumption in the period 2016 and 2024 evolved according the simple index, base 2021, shown in the following table:
Year | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|---|---|---|
Sales Index (base = 2021) | 75.6 | 78.5 | 82.5 | 88.1 | 93.8 | 100 | 104.8 | 107.7 | 107.9 |
Water consumption betwee 2018 and 2020 grew 12.5%.
The chain index of 2018 and 2019 are respectively equal to 105.1 and 106.8.
Taking yera 2016 as base year, \(i_{2024|2016}\) would be equal to:
The average growth rate for water consumption in the whole period was 4.54%. Overall, during the whole period, water consumption grew 36.32%.
Question 5
Wayne Industries reported sales using the chain index shown in the following table:
Year | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|---|---|
Sales Index | 120 | 125 | 135 | 145 | 150 | 160 | 165 |
The average growth rate between 2018 and 2024 was approximately:
The growth rate for sales between 2017 and 2024 is approximately:
The average semi-annual growth rate between 2020 and 2023 is approximately 23.10%.
The value for the semi-annual growth rate, in real terms, if the IPC (fix base) went from 130 in 2020 to 180 in 2023, is approximately equal to 10%.
Question 6
Consider the following data regarding nominal wages for the workers of Watto’s Junkyard. You also have the inflation rate in Tatooine, for the period 2020 and 2024.
Year | 2020 | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|---|
Wage Index (base 2021) | 93.5 | 100 | 104.3 | 103.8 | 109.7 |
Inflation rate | 3.0% | 2.4% | 2.8% | 2.3 % | 3.0% |
- The nominal wage growth rate, from 2020 to 2024, is 17.33%.
- The average growth rate of inflation between 2020 and 2024 is 2%.
- Fill the following table (use 2 decimal places, for example 101.01):
Year | 2021 | 2022 | 2023 | 2024 |
---|---|---|---|---|
Linked-Chain Index for wages |
- The year where the wages had the largest real increase was .
Question 7
Consider the following data with respect to the evolution of the Euro Area GDP (EU27) between 2017 and 2023, constant prices (base 2015), as well as the chain index for prices for the same period:
The inflation rate between 2021 and 2022 was 6.12%.
Prices grew from 2020 to 2024 1.89%.
The average growth rate between 2024 and 2017, for GDP, was 1.33 % every year.
In 2023 and 2024 the real and nominal growth rates (for GDP) were the same.
Question 8
The table below has data on regular consumption goods. You will find prices and quantities, before and after austerity measures were put in place for a economically struggling country. In this period, the LQI and PQI were 91.4 and 91.3 respectively.
Products | Before austerity | After austerity | ||
---|---|---|---|---|
Price | Quantity | Price | Quantity | |
Bread (units) | 0.2 | 420 | 0.25 | 360 |
Milk (Lts) | 0.7 | 360 | 0.80 | 336 |
Assume the time window, between the two periods, was 3 years. The average growth rate for the price of bread was: %. (use two decimals, for example 9.81)
According to the Fisher index, in the studied period, the variation of consumed quantities, for both products, was negative and equal to -8.65%.
The real and nominal growth rates, for sales, for both products, were similar after the implementation of the austerity measures.
Suppose that after the implementation of the austerity measures, and until now, the price of milk dropped 5%. Then, the current price for milk would be (again, use two decimal places, for example 0.56)
Question 9
Public Transportation | Year 1 | Year 2 | ||
---|---|---|---|---|
Trips | Price per trip | Trips | Price Index (Base: year 1) | |
Bus | 1,763,521 | 1.15 | 1,875,345 | 108.70 |
Metro | 3,148,350 | 1.2 | 3,396,138 | 112.50 |
According to the LPI for year 2, prices for public transportation grew 11.17% compared to year 1.
The real change, according to PQI in year 2, was 7.35% compared to year 1.
The composite index for value, in the public transportation sector, for year 2 compared to year 1, represents what type of change?
Question 10
After tracking a basket with 30 goods for 3 years (2022 to 2024), the following data was collected:
2022 | 2023 | 2024 | |
---|---|---|---|
2022 | \(\sum p^k_{2022}q^k_{2022} = 8,562\) | \(\sum p^k_{2022}q^k_{2023}=9,210\) | \(\sum p^k_{2022} q^k_{2024} = 9,920\) |
2023 | \(\sum p^k_{2023}q^k_{2022} = 9,150\) | \(\sum p^k_{2023}q^k_{2023} = 9,584\) | |
2024 | \(\sum p^k_{2024}q^k_{2022}=9,657\) | \(\sum p^k_{2024}q^k_{2024} = 10,013\) |
Fill the following table (use index in hundreds, rounded to the closest integer, for example 107):
2022 | 2023 | 2024 | |
---|---|---|---|
\(LPI_{t|2022}\) | 100 | ||
\(PPI_{t|2022}\) | 100 | ||
\(FPI_{t|2022}\) | 100 |
Question 11
An Index Number is used:The real growth rate, within a given timeframe, corresponds to the nominal growth rate, deflated by the CPI (consumer price index).